3.4 Updating the Entra ID in the database directly

Important: Back up your database before making any manual changes.

To update the database directly, you must know the ObjectID for the person in the MyID database and the ObjectGUID for the person in Entra.

The person's ObjectID is available in the vPeopleUserAccounts view in the MyID database. You can also see this ID in the URL of the View Person screen in the MyID Operator Client; for example:

https://myserver.example.com/MyID/OperatorClient/#/people/A488BFA9-1460-4638-8C22-00DAB3B0F2BC

This example assumes that the person's MyID ObjectID is:

A488BFA9-1460-4638-8C22-00DAB3B0F2BC

and that their Entra ObjectGUID is:

C47486E7-DDFE-43A6-9954-BDD1DF6AA743

To add the Entra ID to the XuSYSExternalReferenceId1 field for the person's user account in MyID, run the following SQL statement against the MyID database:

Copy 
update vPeopleUserAccounts set XuSYSExternalReferenceId1 = 'C47486E7-DDFE-43A6-9954-BDD1DF6AA743' where ObjectID = 'A488BFA9-1460-4638-8C22-00DAB3B0F2BC'

Note: If you use a different field than XuSYSExternalReferenceId1, you must make sure that you configure the External Entra Reference option in the External Systems workflow to use the appropriate field; see section 3.7.3, Setting up the external system.

Once you have linked the person in MyID to the account in Entra, you can request a FIDO device using a credential profile configured for Entra.